Pandas Profiling Report

Dataset statistics

Number of variables	22
Number of observations	4366
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	750.5 KiB
Average record size in memory	176.0 B

Variable types

Numeric	22

Warnings

`purchases` is highly correlated with `quantity_p` and 2 other fields	High correlation
`devolutions` is highly correlated with `quantity_p` and 3 other fields	High correlation
`recency_p` is highly correlated with `avg_recency_days` and 1 other fields	High correlation
`recency_d` is highly correlated with `invoices_d`	High correlation
`quantity_p` is highly correlated with `purchases` and 4 other fields	High correlation
`quantity_d` is highly correlated with `devolutions` and 3 other fields	High correlation
`invoices_p` is highly correlated with `purchases` and 2 other fields	High correlation
`invoices_d` is highly correlated with `recency_d` and 1 other fields	High correlation
`avg_ticket` is highly correlated with `devolutions` and 3 other fields	High correlation
`avg_recency_days` is highly correlated with `recency_p` and 1 other fields	High correlation
`avg_basket_size` is highly correlated with `devolutions` and 3 other fields	High correlation
`avg_variety` is highly correlated with `behavior_score`	High correlation
`gross_revenue` is highly correlated with `purchases` and 1 other fields	High correlation
`relative_revenue` is highly correlated with `relative_quantity` and 2 other fields	High correlation
`relative_quantity` is highly correlated with `relative_revenue` and 1 other fields	High correlation
`monetary_score` is highly correlated with `relative_revenue` and 2 other fields	High correlation
`ticket_score` is highly correlated with `relative_revenue` and 1 other fields	High correlation
`recency_score` is highly correlated with `recency_p` and 1 other fields	High correlation
`behavior_score` is highly correlated with `avg_variety`	High correlation
`purchases` is highly correlated with `quantity_p` and 4 other fields	High correlation
`devolutions` is highly correlated with `recency_d` and 4 other fields	High correlation
`recency_p` is highly correlated with `invoices_p` and 2 other fields	High correlation
`recency_d` is highly correlated with `devolutions` and 4 other fields	High correlation
`quantity_p` is highly correlated with `purchases` and 4 other fields	High correlation
`quantity_d` is highly correlated with `devolutions` and 4 other fields	High correlation
`invoices_p` is highly correlated with `purchases` and 7 other fields	High correlation
`invoices_d` is highly correlated with `devolutions` and 4 other fields	High correlation
`avg_ticket` is highly correlated with `avg_variety` and 2 other fields	High correlation
`avg_recency_days` is highly correlated with `recency_p` and 2 other fields	High correlation
`avg_basket_size` is highly correlated with `purchases` and 3 other fields	High correlation
`avg_variety` is highly correlated with `avg_ticket` and 2 other fields	High correlation
`purchases_pday` is highly correlated with `invoices_p`	High correlation
`gross_revenue` is highly correlated with `purchases` and 4 other fields	High correlation
`relative_revenue` is highly correlated with `devolutions` and 4 other fields	High correlation
`relative_quantity` is highly correlated with `devolutions` and 4 other fields	High correlation
`monetary_score` is highly correlated with `purchases` and 4 other fields	High correlation
`ticket_score` is highly correlated with `avg_ticket` and 2 other fields	High correlation
`recency_score` is highly correlated with `recency_p` and 2 other fields	High correlation
`behavior_score` is highly correlated with `avg_ticket` and 2 other fields	High correlation
`purchases` is highly correlated with `quantity_p` and 3 other fields	High correlation
`devolutions` is highly correlated with `recency_d` and 4 other fields	High correlation
`recency_p` is highly correlated with `avg_recency_days` and 1 other fields	High correlation
`recency_d` is highly correlated with `devolutions` and 4 other fields	High correlation
`quantity_p` is highly correlated with `purchases` and 3 other fields	High correlation
`quantity_d` is highly correlated with `devolutions` and 4 other fields	High correlation
`invoices_p` is highly correlated with `purchases` and 2 other fields	High correlation
`invoices_d` is highly correlated with `devolutions` and 4 other fields	High correlation
`avg_ticket` is highly correlated with `ticket_score`	High correlation
`avg_recency_days` is highly correlated with `recency_p` and 1 other fields	High correlation
`avg_basket_size` is highly correlated with `quantity_p`	High correlation
`avg_variety` is highly correlated with `behavior_score`	High correlation
`gross_revenue` is highly correlated with `purchases` and 3 other fields	High correlation
`relative_revenue` is highly correlated with `devolutions` and 4 other fields	High correlation
`relative_quantity` is highly correlated with `devolutions` and 4 other fields	High correlation
`monetary_score` is highly correlated with `purchases` and 3 other fields	High correlation
`ticket_score` is highly correlated with `avg_ticket`	High correlation
`recency_score` is highly correlated with `recency_p` and 1 other fields	High correlation
`behavior_score` is highly correlated with `avg_variety`	High correlation
`purchases` is highly correlated with `devolutions` and 8 other fields	High correlation
`avg_variety` is highly correlated with `behavior_score`	High correlation
`devolutions` is highly correlated with `purchases` and 5 other fields	High correlation
`quantity_d` is highly correlated with `purchases` and 5 other fields	High correlation
`df_index` is highly correlated with `avg_recency_days` and 1 other fields	High correlation
`avg_basket_size` is highly correlated with `purchases` and 5 other fields	High correlation
`monetary_score` is highly correlated with `purchases` and 5 other fields	High correlation
`avg_recency_days` is highly correlated with `df_index` and 2 other fields	High correlation
`relative_revenue` is highly correlated with `monetary_score` and 2 other fields	High correlation
`quantity_p` is highly correlated with `purchases` and 6 other fields	High correlation
`invoices_d` is highly correlated with `purchases` and 2 other fields	High correlation
`invoices_p` is highly correlated with `purchases` and 3 other fields	High correlation
`gross_revenue` is highly correlated with `purchases` and 4 other fields	High correlation
`behavior_score` is highly correlated with `avg_variety` and 2 other fields	High correlation
`recency_p` is highly correlated with `df_index` and 1 other fields	High correlation
`recency_score` is highly correlated with `avg_recency_days`	High correlation
`relative_quantity` is highly correlated with `monetary_score` and 3 other fields	High correlation
`avg_ticket` is highly correlated with `purchases` and 5 other fields	High correlation
`ticket_score` is highly correlated with `devolutions` and 8 other fields	High correlation
`devolutions` is highly skewed (γ1 = 47.38221518)	Skewed
`quantity_p` is highly skewed (γ1 = 30.93123636)	Skewed
`quantity_d` is highly skewed (γ1 = 45.51559535)	Skewed
`avg_ticket` is highly skewed (γ1 = 46.64636797)	Skewed
`avg_basket_size` is highly skewed (γ1 = 48.13011902)	Skewed
`gross_revenue` is highly skewed (γ1 = 21.69086914)	Skewed
`df_index` has unique values	Unique
`customer_id` has unique values	Unique
`devolutions` has 2778 (63.6%) zeros	Zeros
`quantity_d` has 2778 (63.6%) zeros	Zeros
`invoices_d` has 2778 (63.6%) zeros	Zeros
`behavior_score` has 158 (3.6%) zeros	Zeros

Reproduction

Analysis started	2021-06-20 11:55:00.395274
Analysis finished	2021-06-20 11:56:01.082193
Duration	1 minute and 0.69 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	4366
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2837.469079

Minimum	0
Maximum	5970
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	0
5-th percentile	229.25
Q1	1303.25
median	2733.5
Q3	4423.75
95-th percentile	5635.75
Maximum	5970
Range	5970
Interquartile range (IQR)	3120.5

Descriptive statistics

Standard deviation	1758.395649
Coefficient of variation (CV)	0.6197056603
Kurtosis	-1.238510832
Mean	2837.469079
Median Absolute Deviation (MAD)	1550
Skewness	0.1035389668
Sum	12388390
Variance	3091955.26
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
1254	1	< 0.1%
1266	1	< 0.1%
3311	1	< 0.1%
5356	1	< 0.1%
3307	1	< 0.1%
1258	1	< 0.1%
3303	1	< 0.1%
5348	1	< 0.1%
1426	1	< 0.1%
Other values (4356)	4356	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
5970	1	< 0.1%
5963	1	< 0.1%
5962	1	< 0.1%
5960	1	< 0.1%
5958	1	< 0.1%
5954	1	< 0.1%
5953	1	< 0.1%
5952	1	< 0.1%
5951	1	< 0.1%
5950	1	< 0.1%

customer_id
Real number (ℝ_≥0)

UNIQUE

Distinct	4366
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15301.45121

Minimum	12346
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	12346
5-th percentile	12614.25
Q1	13814.25
median	15303.5
Q3	16779.75
95-th percentile	17984.75
Maximum	18287
Range	5941
Interquartile range (IQR)	2965.5

Descriptive statistics

Standard deviation	1722.144646
Coefficient of variation (CV)	0.1125477984
Kurtosis	-1.195850103
Mean	15301.45121
Median Absolute Deviation (MAD)	1484.5
Skewness	0.0001007032311
Sum	66806136
Variance	2965782.181
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16384	1	< 0.1%
13644	1	< 0.1%
13656	1	< 0.1%
17750	1	< 0.1%
15701	1	< 0.1%
13652	1	< 0.1%
17746	1	< 0.1%
17742	1	< 0.1%
17738	1	< 0.1%
15861	1	< 0.1%
Other values (4356)	4356	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12346	1	< 0.1%
12347	1	< 0.1%
12348	1	< 0.1%
12349	1	< 0.1%
12350	1	< 0.1%
12352	1	< 0.1%
12353	1	< 0.1%
12354	1	< 0.1%
12355	1	< 0.1%
12356	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18281	1	< 0.1%
18280	1	< 0.1%
18278	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%

purchases
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	4280
Distinct (%)	98.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2040.183367

Minimum	0
Maximum	280206.02
Zeros	33
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	0
5-th percentile	107.4875
Q1	303.3075
median	665.82
Q3	1654.0875
95-th percentile	5775.52
Maximum	280206.02
Range	280206.02
Interquartile range (IQR)	1350.78

Descriptive statistics

Standard deviation	8962.013605
Coefficient of variation (CV)	4.392749078
Kurtosis	480.9126511
Mean	2040.183367
Median Absolute Deviation (MAD)	465.995
Skewness	19.38102887
Sum	8907440.58
Variance	80317687.85
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	33	0.8%
76.32	4	0.1%
35.4	3	0.1%
440	3	0.1%
363.65	3	0.1%
15	3	0.1%
71.4	2	< 0.1%
120	2	< 0.1%
590	2	< 0.1%
251.21	2	< 0.1%
Other values (4270)	4309	98.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	33	0.8%
3.75	1	< 0.1%
6.2	1	< 0.1%
6.9	1	< 0.1%
12.75	1	< 0.1%
13.3	1	< 0.1%
15	3	0.1%
17	1	< 0.1%
20.8	2	< 0.1%
25.5	2	< 0.1%

Value	Count	Frequency (%)
280206.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
143825.06	1	< 0.1%
124914.53	1	< 0.1%
117379.63	1	< 0.1%
91062.38	1	< 0.1%
81024.84	1	< 0.1%
77183.6	1	< 0.1%

devolutions
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	1169
Distinct (%)	26.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	140.019787

Minimum	0
Maximum	168469.6
Zeros	2778
Zeros (%)	63.6%
Negative	0
Negative (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	16.575
95-th percentile	191.135
Maximum	168469.6
Range	168469.6
Interquartile range (IQR)	16.575

Descriptive statistics

Standard deviation	2954.51808
Coefficient of variation (CV)	21.10071829
Kurtosis	2530.699539
Mean	140.019787
Median Absolute Deviation (MAD)	0
Skewness	47.38221518
Sum	611326.39
Variance	8729177.088
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2778	63.6%
12.75	21	0.5%
4.95	18	0.4%
9.95	15	0.3%
15	15	0.3%
5.9	12	0.3%
25.5	11	0.3%
4.25	10	0.2%
3.75	9	0.2%
19.9	9	0.2%
Other values (1159)	1468	33.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2778	63.6%
0.42	2	< 0.1%
0.65	1	< 0.1%
0.77	1	< 0.1%
0.95	1	< 0.1%
1.25	5	0.1%
1.45	4	0.1%
1.64	1	< 0.1%
1.65	5	0.1%
1.7	2	< 0.1%

Value	Count	Frequency (%)
168469.6	1	< 0.1%
77183.6	1	< 0.1%
39267	1	< 0.1%
30032.23	1	< 0.1%
22998.4	1	< 0.1%
12158.9	1	< 0.1%
11252.44	1	< 0.1%
8593.15	1	< 0.1%
8495.01	1	< 0.1%
8043.88	1	< 0.1%

recency_p
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	304
Distinct (%)	7.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	94.07558406

Minimum	0
Maximum	373
Zeros	35
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	17
median	51
Q3	147
95-th percentile	318
Maximum	373
Range	373
Interquartile range (IQR)	130

Descriptive statistics

Standard deviation	102.4445304
Coefficient of variation (CV)	1.088959812
Kurtosis	0.3775336914
Mean	94.07558406
Median Absolute Deviation (MAD)	41
Skewness	1.235556949
Sum	410734
Variance	10494.8818
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	103	2.4%
3	94	2.2%
4	94	2.2%
2	90	2.1%
8	79	1.8%
10	77	1.8%
17	74	1.7%
7	72	1.6%
9	71	1.6%
22	64	1.5%
Other values (294)	3548	81.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	35	0.8%
1	103	2.4%
2	90	2.1%
3	94	2.2%
4	94	2.2%
5	48	1.1%
7	72	1.6%
8	79	1.8%
9	71	1.6%
10	77	1.8%

Value	Count	Frequency (%)
373	17	0.4%
372	18	0.4%
371	6	0.1%
369	3	0.1%
368	5	0.1%
367	5	0.1%
366	10	0.2%
365	43	1.0%
364	6	0.1%
362	6	0.1%

recency_d
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	278
Distinct (%)	6.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	280.8964727

Minimum	0
Maximum	373
Zeros	5
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	0
5-th percentile	18
Q1	185
median	365
Q3	365
95-th percentile	365
Maximum	373
Range	373
Interquartile range (IQR)	180

Descriptive statistics

Standard deviation	129.9871958
Coefficient of variation (CV)	0.4627583768
Kurtosis	-0.4666517161
Mean	280.8964727
Median Absolute Deviation (MAD)	0
Skewness	-1.118539076
Sum	1226394
Variance	16896.67107
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
365	2792	63.9%
8	44	1.0%
64	39	0.9%
35	28	0.6%
3	28	0.6%
9	26	0.6%
21	26	0.6%
29	22	0.5%
25	22	0.5%
31	20	0.5%
Other values (268)	1319	30.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5	0.1%
1	20	0.5%
2	13	0.3%
3	28	0.6%
4	13	0.3%
5	4	0.1%
7	10	0.2%
8	44	1.0%
9	26	0.6%
10	8	0.2%

Value	Count	Frequency (%)
373	1	< 0.1%
372	8	0.2%
371	2	< 0.1%
369	2	< 0.1%
368	8	0.2%
367	1	< 0.1%
366	7	0.2%
365	2792	63.9%
364	1	< 0.1%
362	2	< 0.1%

quantity_p
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	777
Distinct (%)	17.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	311.8268438

Minimum	0
Maximum	80996
Zeros	33
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	0
5-th percentile	18
Q1	60
median	115
Q3	234
95-th percentile	710
Maximum	80996
Range	80996
Interquartile range (IQR)	174

Descriptive statistics

Standard deviation	1965.923119
Coefficient of variation (CV)	6.304534579
Kurtosis	1148.530998
Mean	311.8268438
Median Absolute Deviation (MAD)	69
Skewness	30.93123636
Sum	1361436
Variance	3864853.711
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	42	1.0%
60	40	0.9%
67	39	0.9%
51	37	0.8%
72	36	0.8%
52	35	0.8%
66	34	0.8%
0	33	0.8%
70	33	0.8%
90	32	0.7%
Other values (767)	4005	91.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	33	0.8%
1	11	0.3%
2	5	0.1%
3	14	0.3%
4	6	0.1%
5	2	< 0.1%
6	14	0.3%
7	3	0.1%
8	5	0.1%
9	8	0.2%

Value	Count	Frequency (%)
80996	1	< 0.1%
74215	1	< 0.1%
38639	1	< 0.1%
21352	1	< 0.1%
17376	1	< 0.1%
17150	1	< 0.1%
16288	1	< 0.1%
15853	1	< 0.1%
13369	1	< 0.1%
12872	1	< 0.1%

quantity_d
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	186
Distinct (%)	4.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	55.71071919

Minimum	-0
Maximum	80995
Zeros	2778
Zeros (%)	63.6%
Negative	0
Negative (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	-0
5-th percentile	-0
Q1	-0
median	-0
Q3	3
95-th percentile	42
Maximum	80995
Range	80995
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1678.948683
Coefficient of variation (CV)	30.13690556
Kurtosis	2109.732802
Mean	55.71071919
Median Absolute Deviation (MAD)	0
Skewness	45.51559535
Sum	243233
Variance	2818868.681
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0	2778	63.6%
1	349	8.0%
3	173	4.0%
6	90	2.1%
2	89	2.0%
4	75	1.7%
5	45	1.0%
12	45	1.0%
7	42	1.0%
8	40	0.9%
Other values (176)	640	14.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0	2778	63.6%
1	349	8.0%
2	89	2.0%
3	173	4.0%
4	75	1.7%
5	45	1.0%
6	90	2.1%
7	42	1.0%
8	40	0.9%
9	37	0.8%

Value	Count	Frequency (%)
80995	1	< 0.1%
74215	1	< 0.1%
9361	1	< 0.1%
9014	1	< 0.1%
4873	1	< 0.1%
4027	1	< 0.1%
2399	1	< 0.1%
2302	1	< 0.1%
2160	1	< 0.1%
1685	1	< 0.1%

invoices_p
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	60
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.241868988

Minimum	0
Maximum	209
Zeros	33
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	5
95-th percentile	13
Maximum	209
Range	209
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	7.681885185
Coefficient of variation (CV)	1.810967101
Kurtosis	249.7371905
Mean	4.241868988
Median Absolute Deviation (MAD)	1
Skewness	12.0756929
Sum	18520
Variance	59.01135999
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1493	34.2%
2	831	19.0%
3	508	11.6%
4	387	8.9%
5	242	5.5%
6	172	3.9%
7	143	3.3%
8	98	2.2%
9	68	1.6%
10	54	1.2%
Other values (50)	370	8.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	33	0.8%
1	1493	34.2%
2	831	19.0%
3	508	11.6%
4	387	8.9%
5	242	5.5%
6	172	3.9%
7	143	3.3%
8	98	2.2%
9	68	1.6%

Value	Count	Frequency (%)
209	1	< 0.1%
201	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
93	1	< 0.1%
91	1	< 0.1%
86	1	< 0.1%
73	1	< 0.1%
63	1	< 0.1%
62	1	< 0.1%

invoices_d
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	27
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.8364635822

Minimum	0
Maximum	47
Zeros	2778
Zeros (%)	63.6%
Negative	0
Negative (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	4
Maximum	47
Range	47
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	2.136425755
Coefficient of variation (CV)	2.55411688
Kurtosis	134.1595049
Mean	0.8364635822
Median Absolute Deviation (MAD)	0
Skewness	8.846668074
Sum	3652
Variance	4.564315005
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
0	2778	63.6%
1	886	20.3%
2	308	7.1%
3	147	3.4%
4	97	2.2%
5	44	1.0%
6	30	0.7%
7	22	0.5%
8	9	0.2%
9	7	0.2%
Other values (17)	38	0.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2778	63.6%
1	886	20.3%
2	308	7.1%
3	147	3.4%
4	97	2.2%
5	44	1.0%
6	30	0.7%
7	22	0.5%
8	9	0.2%
9	7	0.2%

Value	Count	Frequency (%)
47	1	< 0.1%
45	1	< 0.1%
35	1	< 0.1%
31	1	< 0.1%
27	1	< 0.1%
23	1	< 0.1%
21	1	< 0.1%
19	2	< 0.1%
18	1	< 0.1%
17	2	< 0.1%

avg_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	4304
Distinct (%)	98.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67.89335507

Minimum	0
Maximum	77183.6
Zeros	33
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	0
5-th percentile	4.356321839
Q1	11.99768757
median	17.67979201
Q3	24.79484848
95-th percentile	93.3
Maximum	77183.6
Range	77183.6
Interquartile range (IQR)	12.79716091

Descriptive statistics

Standard deviation	1463.214147
Coefficient of variation (CV)	21.55165473
Kurtosis	2263.833843
Mean	67.89335507
Median Absolute Deviation (MAD)	6.449171759
Skewness	46.64636797
Sum	296422.3883
Variance	2140995.64
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	33	0.8%
15	4	0.1%
76.32	4	0.1%
179	4	0.1%
18.7	3	0.1%
25.5	3	0.1%
24.4	2	< 0.1%
20.8	2	< 0.1%
30	2	< 0.1%
358	2	< 0.1%
Other values (4294)	4307	98.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	33	0.8%
2.101285714	1	< 0.1%
2.150588235	1	< 0.1%
2.241	1	< 0.1%
2.264375	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.504876033	1	< 0.1%
2.50837156	1	< 0.1%
2.54704918	1	< 0.1%

Value	Count	Frequency (%)
77183.6	1	< 0.1%
56157.5	1	< 0.1%
13305.5	1	< 0.1%
4453.43	1	< 0.1%
3861	1	< 0.1%
3096	1	< 0.1%
2033.1	1	< 0.1%
2027.86	1	< 0.1%
1687.2	1	< 0.1%
1377.077778	1	< 0.1%

avg_recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1276
Distinct (%)	29.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	94.64705894

Minimum	0
Maximum	373
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	0
5-th percentile	14
Q1	34.66666667
median	63.63333333
Q3	122.6666667
95-th percentile	298.75
Maximum	373
Range	373
Interquartile range (IQR)	88

Descriptive statistics

Standard deviation	86.5562299
Coefficient of variation (CV)	0.9145157903
Kurtosis	1.722870893
Mean	94.64705894
Median Absolute Deviation (MAD)	35.75
Skewness	1.541130343
Sum	413229.0593
Variance	7491.980935
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
53	29	0.7%
30	24	0.5%
18	23	0.5%
106	22	0.5%
39	22	0.5%
24	21	0.5%
25	20	0.5%
28	20	0.5%
92	20	0.5%
15	19	0.4%
Other values (1266)	4146	95.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	4	0.1%
2	5	0.1%
2.554794521	1	< 0.1%
3	9	0.2%
3.243478261	1	< 0.1%
3.300884956	1	< 0.1%
3.333333333	1	< 0.1%
3.5	1	< 0.1%
3.666666667	1	< 0.1%

Value	Count	Frequency (%)
373	15	0.3%
372	17	0.4%
371	7	0.2%
369	3	0.1%
368	5	0.1%
367	5	0.1%
366	8	0.2%
365	10	0.2%
364	5	0.1%
362	6	0.1%

avg_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	2136
Distinct (%)	48.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	251.6187465

Minimum	0
Maximum	74215
Zeros	33
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	0
5-th percentile	30.54166667
Q1	91
median	160.5666667
Q3	270.25
95-th percentile	598.6
Maximum	74215
Range	74215
Interquartile range (IQR)	179.25

Descriptive statistics

Standard deviation	1308.868296
Coefficient of variation (CV)	5.201791654
Kurtosis	2541.880608
Mean	251.6187465
Median Absolute Deviation (MAD)	81.65
Skewness	48.13011902
Sum	1098567.447
Variance	1713136.215
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	33	0.8%
100	19	0.4%
82	18	0.4%
88	17	0.4%
120	17	0.4%
72	17	0.4%
136	17	0.4%
73	16	0.4%
78	16	0.4%
106	16	0.4%
Other values (2126)	4180	95.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	33	0.8%
1	6	0.1%
1.5	1	< 0.1%
2	5	0.1%
3	2	< 0.1%
3.333333333	1	< 0.1%
4	8	0.2%
5	3	0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%

Value	Count	Frequency (%)
74215	1	< 0.1%
40498.5	1	< 0.1%
7824	1	< 0.1%
6009.333333	1	< 0.1%
4300	1	< 0.1%
4280	1	< 0.1%
3684.47619	1	< 0.1%
3028	1	< 0.1%
2924	1	< 0.1%
2880	1	< 0.1%

avg_variety
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1043
Distinct (%)	23.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.0160071

Minimum	0
Maximum	300.6470588
Zeros	33
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	0
5-th percentile	2.229166667
Q1	9.186363636
median	16.87301587
Q3	28
95-th percentile	59
Maximum	300.6470588
Range	300.6470588
Interquartile range (IQR)	18.81363636

Descriptive statistics

Standard deviation	20.31141942
Coefficient of variation (CV)	0.9225750757
Kurtosis	18.74952384
Mean	22.0160071
Median Absolute Deviation (MAD)	8.873015873
Skewness	3.031567868
Sum	96121.88702
Variance	412.5537589
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	2.3%
13	90	2.1%
14	84	1.9%
10	82	1.9%
11	81	1.9%
9	78	1.8%
6	75	1.7%
7	74	1.7%
5	71	1.6%
8	69	1.6%
Other values (1033)	3563	81.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	33	0.8%
1	99	2.3%
1.2	1	< 0.1%
1.25	1	< 0.1%
1.333333333	2	< 0.1%
1.5	9	0.2%
1.555555556	1	< 0.1%
1.571428571	1	< 0.1%
1.666666667	4	0.1%
1.833333333	1	< 0.1%

Value	Count	Frequency (%)
300.6470588	1	< 0.1%
219	1	< 0.1%
203.5	1	< 0.1%
191	1	< 0.1%
171	1	< 0.1%
164	1	< 0.1%
158	1	< 0.1%
157	1	< 0.1%
153	1	< 0.1%
149	1	< 0.1%

purchases_pday
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1243
Distinct (%)	28.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.4005636754

Minimum	0
Maximum	17
Zeros	33
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0.009592344556
Q1	0.01989485241
median	0.04474578328
Q3	1
95-th percentile	1
Maximum	17
Range	17
Interquartile range (IQR)	0.9801051476

Descriptive statistics

Standard deviation	0.5606445071
Coefficient of variation (CV)	1.399638913
Kurtosis	175.8260771
Mean	0.4005636754
Median Absolute Deviation (MAD)	0.03328437113
Skewness	6.66821218
Sum	1748.861007
Variance	0.3143222633
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1502	34.4%
2	50	1.1%
0	33	0.8%
0.0625	18	0.4%
0.02777777778	17	0.4%
0.02380952381	17	0.4%
0.09090909091	15	0.3%
0.08333333333	14	0.3%
0.02941176471	13	0.3%
0.07692307692	13	0.3%
Other values (1233)	2674	61.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	33	0.8%
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	< 0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	< 0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	< 0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
4	2	< 0.1%
3	4	0.1%
2	50	1.1%
1.142857143	1	< 0.1%
1	1502	34.4%
0.75	1	< 0.1%
0.6666666667	4	0.1%
0.5588235294	1	< 0.1%
0.5388739946	1	< 0.1%

gross_revenue
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	4310
Distinct (%)	98.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1900.16358

Minimum	-4287.63
Maximum	279489.02
Zeros	10
Zeros (%)	0.2%
Negative	42
Negative (%)	1.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	-4287.63
5-th percentile	101.175
Q1	293.1875
median	648.55
Q3	1612.625
95-th percentile	5632.72
Maximum	279489.02
Range	283776.65
Interquartile range (IQR)	1319.4375

Descriptive statistics

Standard deviation	8224.856057
Coefficient of variation (CV)	4.328498948
Kurtosis	606.3365532
Mean	1900.16358
Median Absolute Deviation (MAD)	455.265
Skewness	21.69086914
Sum	8296114.19
Variance	67648257.16
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10	0.2%
76.32	4	0.1%
35.4	3	0.1%
15	3	0.1%
363.65	3	0.1%
440	3	0.1%
215.08	2	< 0.1%
142.5	2	< 0.1%
306.55	2	< 0.1%
428.89	2	< 0.1%
Other values (4300)	4332	99.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-4287.63	1	< 0.1%
-1592.49	1	< 0.1%
-1192.2	1	< 0.1%
-1165.3	1	< 0.1%
-1126	1	< 0.1%
-840.76	1	< 0.1%
-611.86	1	< 0.1%
-451.42	1	< 0.1%
-295.09	1	< 0.1%
-227.44	1	< 0.1%

Value	Count	Frequency (%)
279489.02	1	< 0.1%
256438.49	1	< 0.1%
187482.17	1	< 0.1%
132572.62	1	< 0.1%
123725.45	1	< 0.1%
113384.14	1	< 0.1%
88125.38	1	< 0.1%
65892.08	1	< 0.1%
62653.1	1	< 0.1%
59419.34	1	< 0.1%

relative_revenue
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1548
Distinct (%)	35.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.9464585758

Minimum	-1
Maximum	1
Zeros	10
Zeros (%)	0.2%
Negative	42
Negative (%)	1.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	-1
5-th percentile	0.7752317671
Q1	0.9773601379
median	1
Q3	1
95-th percentile	1
Maximum	1
Range	2
Interquartile range (IQR)	0.02263986212

Descriptive statistics

Standard deviation	0.2102841969
Coefficient of variation (CV)	0.2221800322
Kurtosis	58.90281829
Mean	0.9464585758
Median Absolute Deviation (MAD)	0
Skewness	-7.214265949
Sum	4132.238142
Variance	0.04421944345
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2778	63.6%
-1	33	0.8%
0	10	0.2%
0.9292108372	1	< 0.1%
0.9915204152	1	< 0.1%
0.9534737996	1	< 0.1%
0.9937362982	1	< 0.1%
0.9932761014	1	< 0.1%
-0.965547338	1	< 0.1%
-0.2561983471	1	< 0.1%
Other values (1538)	1538	35.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	33	0.8%
-0.965547338	1	< 0.1%
-0.5961406632	1	< 0.1%
-0.4064582855	1	< 0.1%
-0.3712984055	1	< 0.1%
-0.3333333333	1	< 0.1%
-0.2561983471	1	< 0.1%
-0.1608589951	1	< 0.1%
-0.05743520353	1	< 0.1%
-2.159280493 × 10^-16	1	< 0.1%

Value	Count	Frequency (%)
1	2778	63.6%
0.9998361672	1	< 0.1%
0.9996863718	1	< 0.1%
0.9994487783	1	< 0.1%
0.9994162442	1	< 0.1%
0.9993461799	1	< 0.1%
0.9992302394	1	< 0.1%
0.999085358	1	< 0.1%
0.9990001507	1	< 0.1%
0.9986406047	1	< 0.1%

relative_quantity
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1127
Distinct (%)	25.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.9273829918

Minimum	-1
Maximum	1
Zeros	18
Zeros (%)	0.4%
Negative	47
Negative (%)	1.1%
Memory size	34.2 KiB

Quantile statistics

Minimum	-1
5-th percentile	0.6008860448
Q1	0.9646793976
median	1
Q3	1
95-th percentile	1
Maximum	1
Range	2
Interquartile range (IQR)	0.03532060239

Descriptive statistics

Standard deviation	0.2302652918
Coefficient of variation (CV)	0.2482957892
Kurtosis	40.57015379
Mean	0.9273829918
Median Absolute Deviation (MAD)	0
Skewness	-5.825843262
Sum	4048.954142
Variance	0.05302210461
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2778	63.6%
-1	33	0.8%
0	18	0.4%
0.6	9	0.2%
0.9830508475	8	0.2%
0.9718309859	7	0.2%
0.9512195122	7	0.2%
0.9672131148	7	0.2%
0.8947368421	7	0.2%
0.9574468085	6	0.1%
Other values (1117)	1486	34.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	33	0.8%
-0.9895287958	1	< 0.1%
-0.9874213836	1	< 0.1%
-0.503649635	1	< 0.1%
-0.2978723404	1	< 0.1%
-0.2546374368	1	< 0.1%
-0.1823176508	1	< 0.1%
-0.1363636364	1	< 0.1%
-0.1194029851	1	< 0.1%
-0.1180124224	1	< 0.1%

Value	Count	Frequency (%)
1	2778	63.6%
0.9998446361	1	< 0.1%
0.9993894994	1	< 0.1%
0.9993149121	1	< 0.1%
0.9992890153	1	< 0.1%
0.9990356798	1	< 0.1%
0.9987129987	1	< 0.1%
0.9986666667	1	< 0.1%
0.9986130374	1	< 0.1%
0.9985304923	1	< 0.1%

monetary_score
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	4230
Distinct (%)	96.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.780838168

Minimum	-3
Maximum	5.446364751
Zeros	0
Zeros (%)	0.0%
Negative	54
Negative (%)	1.2%
Memory size	34.2 KiB

Quantile statistics

Minimum	-3
5-th percentile	2.005073211
Q1	2.467145392
median	2.811943454
Q3	3.207533381
95-th percentile	3.750717313
Maximum	5.446364751
Range	8.446364751
Interquartile range (IQR)	0.7403879891

Descriptive statistics

Standard deviation	0.8418262849
Coefficient of variation (CV)	0.3027239393
Kurtosis	25.21260616
Mean	2.780838168
Median Absolute Deviation (MAD)	0.3700442532
Skewness	-3.806544442
Sum	12141.13944
Variance	0.708671494
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-3	54	1.2%
1.882638362	4	0.1%
1.176091259	3	0.1%
2.317018101	3	0.1%
1.549003262	3	0.1%
2.560683592	3	0.1%
2.643452676	3	0.1%
2.317645543	2	< 0.1%
1.898725182	2	< 0.1%
2.309630167	2	< 0.1%
Other values (4220)	4287	98.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-3	54	1.2%
0.4623979979	1	< 0.1%
0.5740312677	1	< 0.1%
1.105510185	1	< 0.1%
1.176091259	3	0.1%
1.230448921	1	< 0.1%
1.318063335	2	< 0.1%
1.40654018	1	< 0.1%
1.477121255	1	< 0.1%
1.485721426	1	< 0.1%

Value	Count	Frequency (%)
5.446364751	1	< 0.1%
5.408983211	1	< 0.1%
5.272959972	1	< 0.1%
5.122453839	1	< 0.1%
5.092459042	1	< 0.1%
5.05455231	1	< 0.1%
4.945101003	1	< 0.1%
4.818833217	1	< 0.1%
4.796942564	1	< 0.1%
4.773927824	1	< 0.1%

ticket_score
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	4289
Distinct (%)	98.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.530895657

Minimum	-3
Maximum	5.188555027
Zeros	0
Zeros (%)	0.0%
Negative	33
Negative (%)	0.8%
Memory size	34.2 KiB

Quantile statistics

Minimum	-3
5-th percentile	0.9401499329
Q1	1.380127542
median	1.548507129
Q3	1.695391211
95-th percentile	2.270908637
Maximum	5.188555027
Range	8.188555027
Interquartile range (IQR)	0.3152636686

Descriptive statistics

Standard deviation	0.5563528036
Coefficient of variation (CV)	0.3634165405
Kurtosis	32.75740056
Mean	1.530895657
Median Absolute Deviation (MAD)	0.1541124923
Skewness	-3.523114853
Sum	6683.89044
Variance	0.309528442
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-3	33	0.8%
1.477121255	5	0.1%
1.707570176	4	0.1%
2.183668357	4	0.1%
2.553883027	4	0.1%
1.619093331	3	0.1%
1.572871602	3	0.1%
1.661812686	3	0.1%
2.618048097	2	< 0.1%
1.558708571	2	< 0.1%
Other values (4279)	4303	98.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-3	33	0.8%
0.6235151036	1	< 0.1%
0.6335872613	1	< 0.1%
0.6514718522	1	< 0.1%
0.655978347	1	< 0.1%
0.6870828446	1	< 0.1%
0.692383507	1	< 0.1%
0.6998162331	1	< 0.1%
0.7004218637	1	< 0.1%
0.7070673264	1	< 0.1%

Value	Count	Frequency (%)
5.188555027	1	< 0.1%
5.050437761	1	< 0.1%
4.425061195	1	< 0.1%
3.949724626	1	< 0.1%
3.887729797	1	< 0.1%
3.791830948	1	< 0.1%
3.609188736	1	< 0.1%
3.608067964	1	< 0.1%
3.528196562	1	< 0.1%
3.439988466	1	< 0.1%

recency_score
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1276
Distinct (%)	29.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.383933061

Minimum	0.51708769
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	0.51708769
5-th percentile	0.5775914349
Q1	0.899235974
median	1.243860756
Q3	1.674436717
95-th percentile	2.581988897
Maximum	10
Range	9.48291231
Interquartile range (IQR)	0.7752007426

Descriptive statistics

Standard deviation	0.7165687406
Coefficient of variation (CV)	0.5177770231
Kurtosis	12.35621029
Mean	1.383933061
Median Absolute Deviation (MAD)	0.3813138501
Skewness	2.35908523
Sum	6042.251746
Variance	0.51347076
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.360827635	29	0.7%
1.79605302	24	0.5%
2.294157339	23	0.5%
1.58113883	22	0.5%
0.966736489	22	0.5%
2	21	0.5%
1.856953382	20	0.5%
1.036951695	20	0.5%
1.961161351	20	0.5%
2.5	19	0.4%
Other values (1266)	4146	95.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.51708769	15	0.3%
0.5177803731	17	0.4%
0.5184758474	7	0.2%
0.5198752449	3	0.1%
0.5205792063	5	0.1%
0.5212860351	5	0.1%
0.521995751	8	0.2%
0.5227083735	10	0.2%
0.5234239226	5	0.1%
0.5248638811	6	0.1%

Value	Count	Frequency (%)
10	1	< 0.1%
7.071067812	4	0.1%
5.773502692	5	0.1%
5.303868512	1	< 0.1%
5	9	0.2%
4.854438564	1	< 0.1%
4.821932062	1	< 0.1%
4.803844614	1	< 0.1%
4.714045208	1	< 0.1%
4.629100499	1	< 0.1%

behavior_score
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	2069
Distinct (%)	47.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.182077829

Minimum	0
Maximum	4.68088823
Zeros	158
Zeros (%)	3.6%
Negative	0
Negative (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0.3699090526
Q1	1.692693537
median	2.292256071
Q3	2.781870214
95-th percentile	3.475445187
Maximum	4.68088823
Range	4.68088823
Interquartile range (IQR)	1.089176677

Descriptive statistics

Standard deviation	0.8823341137
Coefficient of variation (CV)	0.4043550151
Kurtosis	0.1378642302
Mean	2.182077829
Median Absolute Deviation (MAD)	0.5376906246
Skewness	-0.5371999585
Sum	9526.951804
Variance	0.7785134883
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	158	3.6%
2	66	1.5%
1.69019608	64	1.5%
1.806179974	63	1.4%
1.556302501	62	1.4%
2.227886705	61	1.4%
1.908485019	61	1.4%
2.292256071	60	1.4%
0.6020599913	59	1.4%
2.08278537	58	1.3%
Other values (2059)	3654	83.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	158	3.6%
1.871197496 × 10^-11	1	< 0.1%
0.0009363764468	1	< 0.1%
0.009936069621	1	< 0.1%
0.01658984761	1	< 0.1%
0.01697923606	1	< 0.1%
0.05334521255	1	< 0.1%
0.05498533582	1	< 0.1%
0.05834477	1	< 0.1%
0.07897975904	1	< 0.1%

Value	Count	Frequency (%)
4.68088823	1	< 0.1%
4.562066734	1	< 0.1%
4.465992221	1	< 0.1%
4.429687696	1	< 0.1%
4.397314174	1	< 0.1%
4.391799305	1	< 0.1%
4.369382862	1	< 0.1%
4.340979418	1	< 0.1%
4.324730469	1	< 0.1%
4.316724984	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	customer_id	purchases	devolutions	recency_p	recency_d	quantity_p	quantity_d	invoices_p	invoices_d	avg_ticket	avg_recency_days	avg_basket_size	avg_variety	purchases_pday	gross_revenue	relative_revenue	relative_quantity	monetary_score	ticket_score	recency_score	behavior_score
0	0	17850	5391.21	102.58	372.0	302.0	35.0	21.0	34.0	1.0	18.152222	124.333333	50.970588	8.735294	17.000000	5288.63	0.962656	0.250000	3.723343	1.559960	0.893237	0.453063
1	1	13047	3237.54	158.44	31.0	31.0	132.0	6.0	10.0	8.0	18.822907	26.642857	139.100000	17.200000	0.029155	3079.10	0.906690	0.913043	3.488424	1.575717	1.901991	2.045657
2	2	12583	7281.38	94.04	2.0	56.0	1569.0	50.0	15.0	3.0	29.479271	20.722222	337.333333	16.466667	0.040323	7187.34	0.974499	0.938233	3.856568	1.770547	2.145596	2.224704
3	3	13748	948.25	0.00	95.0	365.0	169.0	-0.0	5.0	0.0	33.866071	93.250000	87.800000	5.600000	0.017921	948.25	1.000000	1.000000	2.976923	1.830795	1.030052	1.496376
4	4	15100	876.00	240.90	333.0	330.0	48.0	22.0	3.0	3.0	292.000000	62.166667	26.666667	1.000000	0.073171	635.10	0.568627	0.371429	2.802842	2.766413	1.258218	0.000000
5	5	15291	4668.30	71.79	25.0	172.0	508.0	27.0	15.0	5.0	45.323301	21.941176	140.200000	6.866667	0.042980	4596.51	0.969709	0.899065	3.662428	1.957352	2.087816	1.459004
6	6	14688	5630.87	523.49	7.0	7.0	579.0	281.0	21.0	6.0	17.219786	17.761905	172.428571	15.571429	0.057221	5107.38	0.829880	0.346512	3.708198	1.537058	2.308668	0.685739
7	7	17809	5411.91	784.29	16.0	16.0	961.0	41.0	12.0	3.0	88.719836	31.083333	171.416667	5.083333	0.033520	4627.62	0.746848	0.918164	3.665358	2.249051	1.765470	0.968453
8	8	15311	60767.90	1348.56	0.0	0.0	2167.0	231.0	91.0	27.0	25.543464	4.098901	419.714286	26.142857	0.243316	59419.34	0.956580	0.807339	4.773928	1.708310	4.428552	2.189199
9	9	14527	8508.82	797.44	2.0	8.0	198.0	3.0	55.0	31.0	8.753930	5.828125	37.981818	17.672727	0.149457	7711.38	0.828623	0.970149	3.887132	1.243233	3.826919	2.005384

Last rows

	df_index	customer_id	purchases	devolutions	recency_p	recency_d	quantity_p	quantity_d	invoices_p	invoices_d	avg_ticket	avg_recency_days	avg_basket_size	avg_variety	purchases_pday	gross_revenue	relative_revenue	relative_quantity	monetary_score	ticket_score	recency_score	behavior_score
4356	5950	16000	12393.70	0.00	2.0	365.0	770.0	-0.0	3.0	0.0	1377.077778	2.0	1703.333333	3.0	3.0	12393.70	1.000000	1.000000	4.093201	3.439988	5.773503	0.954243
4357	5951	15195	3861.00	0.00	2.0	365.0	1404.0	-0.0	1.0	0.0	3861.000000	2.0	1404.000000	1.0	1.0	3861.00	1.000000	1.000000	3.586700	3.887730	5.773503	0.000000
4358	5952	14087	194.42	12.75	2.0	2.0	113.0	1.0	1.0	1.0	2.817681	2.0	251.000000	69.0	1.0	181.67	0.876913	0.982456	2.259283	0.750922	5.773503	3.168441
4359	5953	14204	161.03	0.00	2.0	365.0	21.0	-0.0	1.0	0.0	3.659773	2.0	82.000000	44.0	1.0	161.03	1.000000	1.000000	2.206907	0.864484	5.773503	3.286905
4360	5954	15471	469.48	0.00	2.0	365.0	102.0	-0.0	1.0	0.0	6.097143	2.0	266.000000	77.0	1.0	469.48	1.000000	1.000000	2.671617	1.086156	5.773503	3.772981
4361	5958	13436	196.89	0.00	1.0	365.0	58.0	-0.0	1.0	0.0	16.407500	1.0	76.000000	12.0	1.0	196.89	1.000000	1.000000	2.294224	1.516072	7.071068	2.158362
4362	5960	15520	343.50	0.00	1.0	365.0	134.0	-0.0	1.0	0.0	19.083333	1.0	314.000000	18.0	1.0	343.50	1.000000	1.000000	2.535927	1.581684	7.071068	2.510545
4363	5962	13298	360.00	0.00	1.0	365.0	96.0	-0.0	1.0	0.0	180.000000	1.0	96.000000	2.0	1.0	360.00	1.000000	1.000000	2.556303	2.556303	7.071068	0.602060
4364	5963	14569	227.39	0.00	1.0	365.0	70.0	-0.0	1.0	0.0	18.949167	1.0	79.000000	12.0	1.0	227.39	1.000000	1.000000	2.356771	1.578620	7.071068	2.158362
4365	5970	12713	848.55	0.00	0.0	365.0	101.0	-0.0	1.0	0.0	22.330263	0.0	508.000000	38.0	1.0	848.55	1.000000	1.000000	2.928677	1.649924	10.000000	3.159567

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows